UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm1ugJ9dLgaR/SywGxVrIuEoryHBjf0wiOiFgtv1UUYU='
WHERE
key_id = '5d43f1f2dec46b33a638cdb89b04c4ce8a2e18e656b96f89a6214773066018ec'
AND (
token = 'm1ugJ9dLgaR/SywGxVrIuEoryHBjf0wiOiFgtv1UUYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)