UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAUkrq/hHC3ivjw62gj2MGwXTenmk4pCAzjEOVGTVCU='
WHERE
key_id = '5defa4f1df68b085e58d60c2c8d9c0a092a5bc306fd8c9eac4fef3c87a27dcaa'
AND (
token = 'ZAUkrq/hHC3ivjw62gj2MGwXTenmk4pCAzjEOVGTVCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)