UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P2JhddYatLWEN7e7XOg/8GzqNjbXJ2WbSUBr9lP2988='
WHERE
key_id = 'ae1f72b77247cc8923d8114f3fd963849af13870c2ec3cebafd7eabe93736268'
AND (
token = 'P2JhddYatLWEN7e7XOg/8GzqNjbXJ2WbSUBr9lP2988='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)