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