UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIWTN0KebTZ4fQd9WCLjUSi2olM/9UkgRBLlHJS2urg='
WHERE
key_id = '9e1a1536f888d1b1a708b3456ef480eb20b13270ed26c79cf366fa57b0ee903a'
AND (
token = 'pIWTN0KebTZ4fQd9WCLjUSi2olM/9UkgRBLlHJS2urg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)