UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NQ0Sn1MpBQMtsO4GH/rhl5urOM2OZf9HyNRJezxxGOQ='
WHERE
key_id = 'b86e9c3cfc9e32920f89f3df3bcb4eb65ae0fcd7c7a8efbf0c8245cefc4bffd1'
AND (
token = 'NQ0Sn1MpBQMtsO4GH/rhl5urOM2OZf9HyNRJezxxGOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)