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