UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/PceNTfpfu3K3O9RFD4PATtwCHAHhxC9thLKwXFNRfE='
WHERE
key_id = '8dd52916f3aecbb6d50bd7af1d0f11d03bd97307cf25f571fa3c3ff5f8793a15'
AND (
token = '/PceNTfpfu3K3O9RFD4PATtwCHAHhxC9thLKwXFNRfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)