UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iDIlrRkWwR4qoSZgBeMQVj4TTAIjHcUmkanTRodAH9Q='
WHERE
key_id = 'a7295fb34bc4a38efa67b7b2489f9bd91fac03fd442f745623622e3a3d0b6cdc'
AND (
token = 'iDIlrRkWwR4qoSZgBeMQVj4TTAIjHcUmkanTRodAH9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)