UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iP+iZriYWL43pY7ay4wpFUFCY1Pi2urr8ZKVJUJf88k='
WHERE
key_id = '83f30cbce3958d7fa4509decb2e7b6ebebfcd15821d635e9a3b2fbf21a81fe00'
AND (
token = 'iP+iZriYWL43pY7ay4wpFUFCY1Pi2urr8ZKVJUJf88k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)