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