UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XMzD1wfqAVxu6aYt09ui6RLnN+5ALNsE+EX8WyINQrE='
WHERE
key_id = 'be5c8d43e0bf178d94f55e895d4fa00c5866ee17fc141c8a054441fd275f8d45'
AND (
token = 'XMzD1wfqAVxu6aYt09ui6RLnN+5ALNsE+EX8WyINQrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)