UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lBVcrVyNue4L44EhfsfPJo7PlwV9Me7Ry686qVQbWXQ='
WHERE
key_id = '48030b1f1a6e9d6d64f91c010d624b6297e0b1254daafc8d602046343be762e7'
AND (
token = 'lBVcrVyNue4L44EhfsfPJo7PlwV9Me7Ry686qVQbWXQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)