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