UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'whigsPS7N5OW37Od5R5c5CDCgI6r31D8QlEjFEi8g40='
WHERE
key_id = '27b1bd99d3fda46545501bbea90826bd8a86a829ccd1f175a2458dce6883beba'
AND (
token = 'whigsPS7N5OW37Od5R5c5CDCgI6r31D8QlEjFEi8g40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)