UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nItbyebTsErXhVo00cCN1oHvAb4JjrknLL17rBrP0pE='
WHERE
key_id = '5432630b1483bbd675c6b350debf149cdca8baa889c8c2ef8e8edd8486b3cf47'
AND (
token = 'nItbyebTsErXhVo00cCN1oHvAb4JjrknLL17rBrP0pE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)