UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTQfgf7KkCCZMx4eW7ckKIWkP+NNdR1pOdG0jjDqHY8='
WHERE
key_id = '8cb996a1fa104ee0066478ee08a2032f3fffe8f7788a83ceb3acef3c971fc37a'
AND (
token = 'CTQfgf7KkCCZMx4eW7ckKIWkP+NNdR1pOdG0jjDqHY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)