UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAroqMRhRCbUahzAa867LS9ULQZmx9L2jv79wc7qeRs='
WHERE
key_id = '46293714a8cd00e6c55c1fb92f1d58b2452b08d21defee2d1c8ee205574a44cb'
AND (
token = 'ZAroqMRhRCbUahzAa867LS9ULQZmx9L2jv79wc7qeRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)