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