UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yVZ+ucT99MgL1owk4n6X85NdTmgTDI1nuoSvjgxnIdI='
WHERE
key_id = '8414bc57332b913d6f3d52ca6bf1b1b62dfd7cfcb318f5fe040549d6ce9d7213'
AND (
token = 'yVZ+ucT99MgL1owk4n6X85NdTmgTDI1nuoSvjgxnIdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)