UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czZIW+MdHLbTmgl9GQ/pkhzYgm8zUP6nUWLDLSujtwA='
WHERE
key_id = '142eaee5ec2180b2b6c0f50a75f1eea883b22310c99915079693e48df6f7e8d1'
AND (
token = 'czZIW+MdHLbTmgl9GQ/pkhzYgm8zUP6nUWLDLSujtwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)