UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O8LAo6B1TalEIHD0hRKDKbjneMd+Gdk/YRk/giJ7i5c='
WHERE
key_id = 'd46643dc94aad494ddf11046d518be20de1795a62c807115e523a47f4f7a6bdd'
AND (
token = 'O8LAo6B1TalEIHD0hRKDKbjneMd+Gdk/YRk/giJ7i5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)