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