UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7CHWdMBAuZoUTFrh2WbKOeV6jVcCcLaETtAcAAQ4Rc0='
WHERE
key_id = '14ef365c73ec87cbcb739255357808c83a4516f480366b526217b89aff2e2b05'
AND (
token = '7CHWdMBAuZoUTFrh2WbKOeV6jVcCcLaETtAcAAQ4Rc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)