UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YyuJIgc99bAvnyMTreXKiE2JnWC4BkPxMJVa6vLbA2I='
WHERE
key_id = 'ad1246e64dcdac3f80521f472c220bc83b2670960f95e1e3b9b4558c7d874ca9'
AND (
token = 'YyuJIgc99bAvnyMTreXKiE2JnWC4BkPxMJVa6vLbA2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)